﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_ALERTS_TASKS_HISTORY_EXCED_TASK_IN')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_ALERTS_TASKS_HISTORY_EXCED_TASK_IN
	END

GO

CREATE Procedure dbo.PRC_TB_ALERTS_TASKS_HISTORY_EXCED_TASK_IN
	(
		@TATH_ALERT_TASK_ID int,
		@TATH_WEEKEND int,
		@TATH_HOLIDAY int,
		@TATH_HOUR_DAY int,
		@TATH_PERCENT int
	)

AS

insert into TB_ALERTS_TASKS_HISTORY_EXCED_TASK
(TATH_ALERT_TASK_ID,
TATH_WEEKEND,
TATH_HOLIDAY,
TATH_HOUR_DAY,
TATH_PERCENT)
values
(@TATH_ALERT_TASK_ID,
@TATH_WEEKEND,
@TATH_HOLIDAY,
@TATH_HOUR_DAY,
@TATH_PERCENT)

GO

GRANT EXEC ON dbo.PRC_TB_ALERTS_TASKS_HISTORY_EXCED_TASK_IN TO PUBLIC

GO

